﻿CREATE VIEW [acms].[ControlType_View]
AS 
	SELECT 
		Id,
		SiteId,
		Name,
		AdminControlType,
		SearchXPath,
		Custom,
		Deleted,
		VersionId
	 FROM [ControlTypes]
	 WHERE Deleted = 0
;